SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 52451: In SAS® OLAP cubes that support multiple languages, dimension table names cannot exceed 32 characters

DetailsAboutRate It

In SAS OLAP cubes that support multiple languages, dimension table names cannot exceed 32 characters. The 32-character limitation includes the libref, ‘.’ separator, table name, and any non-default locale as specified in the USER_DEFINED_TRANSLATIONS statement.

In the following example, the default dimension table name is Mylib.Cars, and the following locales are specified with the USER_DEFINED_TRANSLATIONS statement:

User_Defined_Translations EN_US JA_JP PL_PL ;

In this case, all of the following dimension table names must contain 32 characters or less.

  • Mylib.Cars
  • Mylib.CarsJA_JP
  • Mylib.CarsPL_PL

If the 32-character limit is exceeded, you might see errors that are similar to these.

ERROR: File MYLIBREF.XXXXX does not exist.
ERROR: File MYLIBREF.XXXXX does not exist.
ERROR: Cube "CUBENAME" cannot be created.

To avoid receiving these error messages, ensure that none of your dimension table names exceed 32 characters when the libref, separator, and any specified locales are included.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS OLAP Serverz/OS9.1 TS1M09.4 TS1M2
Microsoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M0
Microsoft Windows 2000 Advanced Server9.1 TS1M0
Microsoft Windows 2000 Datacenter Server9.1 TS1M0
Microsoft Windows 2000 Server9.1 TS1M0
Microsoft Windows 2000 Professional9.1 TS1M0
Microsoft Windows NT Workstation9.1 TS1M0
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M0
Microsoft Windows Server 2003 Standard Edition9.1 TS1M0
Microsoft Windows XP Professional9.1 TS1M0
64-bit Enabled AIX9.1 TS1M09.4 TS1M2
64-bit Enabled HP-UX9.1 TS1M09.4 TS1M2
64-bit Enabled Solaris9.1 TS1M09.4 TS1M2
HP-UX IPF9.1 TS1M09.4 TS1M2
Linux9.1 TS1M09.4 TS1M2
OpenVMS Alpha9.1 TS1M09.4 TS1M2
Tru64 UNIX9.1 TS1M09.4 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.